package com.fly.springbootTemplate.dao;

import com.fly.springbootTemplate.entity.dto.StudentDto;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface StudentDetailDao {
    //增加学生详情
    boolean insertStudentDetail(StudentDto studentDto);
    //删除学生详情
    boolean deleteStudentDetail(Integer sno);
    //修改学生详情
    boolean updateStudentDetail(StudentDto studentDto);
    //查询学生详情
    //内连接-外连接-左连接-右链接
    //inner join t_student on t_student_detail.sno = t_student.sno
    //left join t_student on t_student_detail.sno = t_student.sno
    //right join t_student on t_student_detail.sno = t_student.sno
    List<StudentDto> selectAllStudentDetail();
    //根据id查询学生详情
    StudentDto selectStudentDetailBySno(Integer sno);
}
